Model Table SUB PROJECT

This model dimension represents sub projects and is based on the IFS Cloud dimension DIM_SUB_PROJECT. All models that refer to this dimension will have the attributes and hierarchies as described below.

Natural parent is project, i.e. each project has its own set of sub projects. A sub project can however have another sub project as a sub project parent.

Attributes

Attribute	Description (where applicable)
Department	The department (DEPARTMENT) referenced by the sub project
L1	Level 1 in Sub Project hierarchy structure
L10	Level 10 in Sub Project hierarchy structure
L2	Level 2 in Sub Project hierarchy structure
L3	Level 3 in Sub Project hierarchy structure
L4	Level 4 in Sub Project hierarchy structure
L5	Level 5 in Sub Project hierarchy structure
L6	Level 6 in Sub Project hierarchy structure
L7	Level 7 in Sub Project hierarchy structure
L8	Level 8 in Sub Project hierarchy structure
L9	Level 9 in Sub Project hierarchy structure
Project	The project identity that the sub project belongs to. (PROJECT_ID)
Sub Project	Defined as PROJECT_ID + ' - ' +SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project Description	The description of the sub project (SUB_PROJECT_DESCRIPTION)
Sub Project Id	The identity of the sub project (SUB_PROJECT_ID)
Sub Project Id Description	Defined as SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project Manager	Name of the sub project manager (MANAGER_NAME)

Hierarchies

Hierarchy	Level
SubProjectHy
	Project
	L1
	L2
	L3
	L4
	L5
	L6
	L7
	L8
	L9
	L10

USED BY MODEL(S)

Model Name

Procurement

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
SUB PROJECT	DIM_SUB_PROJECT_TM	DIM_SUB_PROJECT_BI	DIM_SUB_PROJECT	On Line